﻿CREATE VIEW [acms].[UserPostUploadAverage_View]
AS 
	SELECT a.*,
		(Select AVG(Score) From  [acms].[UserPostUploadVote] where [acms].[UserPostUploadVote].[UserPostUploadId] = a.Id) as Average
	FROM [UserPostUpload_View] a
;